
--- ATUALIZAR LIMITE 150 CAIXA---

SELECT CODIGO_CLIENTE, CLIENTE_VAREJO,LIMITE_CREDITO, LIMITE_CREDITO_TOTAL, STATUS FROM CLIENTES_VAREJO 
WHERE CODIGO_CLIENTE IN ('D183','X509','X838','D044','C578','C592','C417','X651','X777','B988','C984','D286','D289','D290',
'X726','C588','C905','C940','C912','X420','8676','A545','C958','D187','C902','A724','C796','C832','C894','C373','C157','C245',
'C384','C425','C947','9318','C694','B785','C794','D082','D012','C994','C423','B058','C835','C799','C930','C618','C819','D016',
'9602','X375','D014','C918','C948','8840','C775','C330','C577','A824','B256','B639','D027','D141','B770','X727','X686','D172',
'X710','C783','C383','A811','C426','C971','8314','C606','C886','C797','D043','9922','C366','D004','C878','C941','C265','C740',
'B786','D017','D005','X605','X517','C730','X837','A949','7127','C873','C892','C945','D041','C944','C923','C785','D083','D171',
'D096','D158','X569','X896','X897','8497','C935','C145','C970','8702','9655','D052','9312','9714','D135','C057','D282','D283',
'D197','C293','B669','A962','C268','B765','C057','B939','B319','C098','C122','B682','B763','C058','B788','B373','C110','C899',
'B471','B750','C105','B670','B832','C097','C063','C253','C054','C206','C220','B780','C284','C255','B756','C108','D090','D157',
'C037','C109','B662','C669','B615','B928','C007','C065','C235','C410','B838','X313','C185','B073','C124','C077','B832','C097',
'B477','B867','B924','B087','B840','C062','B739','B563','B197','C056','B865','X514','X512','D199','B107','8676','A545','D132',
'X881','D065','D198','C863','X414','C972','X797','C409','C412','C461','C476','C477','C573','C638','C916','C922','D173','D191',
'C932','C973','D010','X566','C983','D125','D126','D127','D128','D129','D130','D131','D159','D168','D285')

SELECT * FROM LOJA_VENDEDORES WHERE VENDEDOR = 'C057'
SELECT * FROM CLIENTES_VAREJO WHERE CODIGO_CLIENTE = 'C057'

/* 
UPDATE CLIENTES_VAREJO  SET LIMITE_CREDITO_TOTAL = '150.00' 
WHERE CODIGO_CLIENTE IN ('B073') 
/*

